﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="CI_ELE_AUTH_GENERATOR.aspx.cs" Inherits="StreetSmartAdmin.newtest" %>

<%@ Register assembly="Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" namespace="Microsoft.Reporting.WebForms" tagprefix="rsweb" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <style type="text/css">
        body
        {
        font-family:"Times New Roman";
        }
    </style>
    <script>
        function goBack() {
            window.history.back()
        }
    </script>

</head>
<body>
    <form id="form1" runat="server">
    <div>
    <center>
    <h1>C&I Authority to Proceed</h1>
        <rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Times New Roman" 
            Font-Size="Medium" InteractiveDeviceInfos="(Collection)" 
            WaitMessageFont-Names="Verdana" WaitMessageFont-Size="14pt" Height="11.7in" 
            Width="7.64in" style="text-align: center" BorderStyle="Solid">
            <LocalReport ReportPath="Report1.rdlc">
                <DataSources>

                    <rsweb:ReportDataSource DataSourceId="SqlDataSource1" Name="DataSet1" />
                    <rsweb:ReportDataSource DataSourceId="SqlDataSource2" Name="DataSet2" />
                </DataSources>
            </LocalReport>
        </rsweb:ReportViewer>
        <input type="button" value="Back" onclick="goBack()" />
        </center>

        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:SQLServer2005DBConnectionString %>" 
            SelectCommand="SELECT * FROM [tblCI] WHERE ([USERID] = @USERID)">
            <SelectParameters>
                <asp:SessionParameter Name="USERID" SessionField="USERID" Type="Int32" />
            </SelectParameters>
        </asp:SqlDataSource>
        <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
            ConnectionString="<%$ ConnectionStrings:SQLServer2005DBConnectionString %>" 
            SelectCommand="SELECT * FROM [tblCI_ELEC_SITE_DETAIL] WHERE ([USERID] = @USERID)">
            <SelectParameters>
                <asp:SessionParameter Name="USERID" SessionField="USERID" Type="Int32" />
            </SelectParameters>
        </asp:SqlDataSource>
        <asp:ScriptManager ID="ScriptManager1" runat="server">
        </asp:ScriptManager>
    
    </div>
    </form>
</body>
</html>
